An Alternative Relational OLAP Modeling Approach

Schema design is one of the fundamentals in database theory and practice as well. In this paper, we discuss the problem of locally valid dimensional attributes in a classification hierarchy of a typical OLAP scenario. In a first step, we show that the traditional star and snowflake schema approach is not feasible in this very natural case of a hierarchy. Therefore, we sketch two alternative modeling approaches resulting in practical solutions and a seamless extension of the traditional star and snowflake schema approach: In a pure relational approach, we replace each dimension table of a star / snowflake schema by a set of views directly reflecting the classification hierarchy. The second approach takes advantage of the object-relational extensions. Using object-relational techniques in the context for the relational representation of a multidimensional OLAP scenario is a novel approach and promises a clean and smooth schema design

Train Collision Avoidance with Mobile Devices for Sparsely Used Railway Lines

This paper shows the results of a communication range measurement campaign performed with mobile onboard units of a fully de-centralized train collision avoidance safety overlay system in typical environments of sparsely used railway lines. The most critical sections of the track with respect to a direct train-to-train communication channel were identified and selected for measurements in different antenna configurations. The measurement results justify the conclusion that the direct train-to-train communication channel along typical sparsely used railway lines fits the requirements of mobile onboard units of the train collision avoidance system

Multi-objective scheduling for real-time data warehouses

The issue of write-read contention is one of the most prevalent problems when deploying real-time data warehouses. With increasing load, updates are increasingly delayed and previously fast queries tend to be slowed down considerably. However, depending on the user requirements, we can improve the response time or the data quality by scheduling the queries and updates appropriately. If both criteria are to be considered simultaneously, we are faced with a so-called multi-objective optimization problem. We transformed this problem into a knapsack problem with additional inequalities and solved it efficiently. Based on our solution, we developed a scheduling approach that provides the optimal schedule with regard to the user requirements at any given point in time. We evaluated our scheduling in an extensive experimental study, where we compared our approach with the respective optimal schedule policies of each single optimization objective

Isospin Breaking Corrections to the HVP with Domain Wall Fermions

We present results for the QED and strong isospin breaking corrections to the hadronic vacuum polarization using $N_f=2+1$ Domain Wall fermions. QED is included in an electro-quenched setup using two different methods, a stochastic and a perturbative approach. Results and statistical errors from both methods are directly compared with each other.Comment: 8 pages, 6 figures, presented at the 35th International Symposium on Lattice Field Theory (Lattice 2017), Granada, Spain, June 18-24, 201

COMB: Cell based Orientation aware MANET Broadcast MAC layer

The design of a collision avoidance system for trains implies the design of a MAC layer for their specific requirements. It should be efficient, reliable, use broadcast and support wireless mobile ad hoc networks (MANETs) with high user speeds. Therefore we are using awareness techniques, which allow a certain channel assignment, despite the absence of infrastructure. This paper presents a new MAC layer protocol designed for broadcast MANETs called COMB (Cell-based Orientation-aware MANET Broadcast). In principle, COMB allows the realization of a collision free transmission, high speed is supported and no handshake is required. COMB is based on localization aware cross layer dimensioned CDMA cells, and uses the SOTDMA protocol as intra cell scheme, while the inter cell scheme relies on direction and speed awareness

Guanabenz in the horse – A preliminary report on clinical effects and comparison to clonidine and other alpha-2 adrenergic agonists

In veterinary medicine, a number of alpha-2 receptor agonists are marketed as sedatives/hypnotics and analgesics, with their principal use being the chemical restraint of large and small animals. Guanabenz (Wytensin®) is an alpha-2 adrenergic receptor agonist marketed for use in humans as an anti-hypertensive agent. Recent reports indicate that guanabenz has been administered to horses in small doses (0.04 mg/kg) for its anti-hypertensive effects. While this offers both benefits of sedation of the horse as well as amelioration of pulmonary hypertension during running exercise and consequent Exercise-Induced Pulmonary Hemorrhage (EIPH), guanabenz is currently proscribed in most racing jurisdictions and its administration to a racing horse can lead to penalties. The Association of Racing Commissioners International (ARCI) lists guanabenz as an ARCI Class 3 agent; Class 3 agents include bronchodilators, anabolic steroids and other drugs with primary effects on the autonomic nervous system, procaine, antihistamines with sedative properties and diuretics and includes amitraz, clonidine, xylazine, detomidine, medetomidine, and romifidine. Guanabenz is unique among alpha-2 agonists in that it differentiates into E- and Z-forms (Fig. 1), with the Z-form lacking hypotensive properties, yet with both E- and Z-forms able to afford relief to cellular stresses related to inflammation or degenerative diseases. The objective of the study was a preliminary description of the pharmacological properties of guanabenz in comparison with clonidine and a number of other alpha-2 agonists. The goal was clinical evaluation of their sedative, analgesic and related activities with the goal of increasing our understanding of the clinical use of such medications and also as a possible prophylaxis for Exercise- Induced Pulmonary Hemorrhage. The clinical study of guanabenz and clonidine was performed in a complete crossover strategy using quantitative markers of sedation, antinociception, heart rate, blood and urine glucose following administration of each compound in five horses. Amitraz, detomidine, medetomidine, romifidine, and xylazine were studied in one horse each. The sedation was quantified by measuring head droop and locomotor activity, while antinociception was measured by Hoof Withdrawal Reflex Latency. Heart rates, urine glucose, urine production and urine specific gravities were also determined by standard clinical chemistry techniques. Guanabenz serum levels and related urinary guanabenz glucuronide levels were determined by established Liquid Chromatography-tandem Mass Spectrometric (LC-MS) methods. In result the clinically effective doses (0.2 mg/kg) of guanabenz produced a rapid and intense sedative effect, with sagging of the lower lip, sunken eyelids, and marked head droop corresponding to plasma guanabenz concentrations that peaked at 120 ng/mL at 2.5 min post-injection (Fig. 2). The initial head height above the ground is considered 100 %, and head heights fell to values ranging 18–40 % with guanabenz, all of which are greater than a 50 % reduction in head height, considered a full clinically useful sedative effect. Despite the intensity of the sedation, all horses remained standing and were able to walk, and the sedation and head droop responses were rapidly reversed by intravenous administration of the alpha-2 receptor antagonist yohimbine, reversals occurring within 10 min of administration. As a pilot investigation this study was extended to six other members of the alpha-2 agonist group, clonidine administered to five horses, and amitraz, detomidine, medetomidine, romifidine, and xylazine to one horse each. Hoof Withdrawal Reflex Latency evaluation demonstrated the considerable analgesic properties of guanabenz, greater than the corresponding potencies among clonidine, detomidine, romifidine, medetomidine and xylazine. Heart rate monitoring showed guanabenz as possessing capacity for prolonged bradycardia, with effects of a single dose lasting for up to 3.5 hr, in contrast with clonidine (1 hr), amitraz (2 hr), detomidine (\u3c1 hr), medetomidine (1 hr), romifidine (2 hr), and xylazine (\u3c1 hr). Peak urine production following guanabenz administration occurred between 1.5 and 3.0 hr after administration (Fig. 6), as indicated by the steeper decline of the urine volume curve during that period. Urine specific gravity dropped to a low of about 1.006 at 2.0 hr after administration and remained at this level for ~1.0 hr. Urine pH remained at 8, and urine protein was negative throughout testing. The other alpha-2 agonists evaluated also caused an increased urine production with a concomitant decrease in specific gravity. The effect of guanabenz had the longest duration on increased urine volume, lasting about 3.0 hr. Xylazine had the shortest diuretic effect, persisting for only about 1.0 hr. Guanabenz along with romifidine and detomidine induced glucosuria whereas other alpha-2 agonists did not. Hyperglycemia and the corresponding glucosuria resulted in a significant diuresis, as shown by the cumulative urine volume. Guanabenz along with amitraz, detomidine and xylazine also produced measurable sedation presenting as reduced locomotor activity (Table 1). While all alpha-2 agonists showed qualitatively similar pharmacological responses, only guanabenz produced an intense and relatively prolonged antinociceptive response. The study is limited by the number of horses examined (five each for guanabenz and clonidine, five for repeat studies that included yohimbine antagonism, and one each for the other agonists). Study design was focused on clinical evaluation of agonist similarities and differences and thus did not specifically generate data for detailed statistical evaluation. In conclusion these studies show that a 100 mg IV dose of guanabenz rapidly induces clinically useful sedation, analgesia and antinociception effects that are more intense and considerably longer-lasting than those produced by other alpha-2 receptor agonists evaluated. Guanabenz also remains detectable in serum up to 8-hours following administration at doses as low as 0.04 mg/kg. In the work reported here, guanabenz administered at 0.2 mg/kg IV showed peak concentrations in serum of 120 ng/ mL at 2.5 min and was detectable for up to 4 hr with its glucuronide metabolite peaking at 120 min post-administration. Although we did not investigate the combination of guanabenz with opioid drugs such as butorphanol for pain management, guanabenz may well be a drug of choice among the other alpha-2 agonists evaluated in this study for administration with opioids for pain management based on maintaining maximum levels of analgesia for longer periods of time. These experiments suggest considerable clinical potential for guanabenz as a sedative and a relatively long-lasting analgesic in equine medicine. Based on these pharmacological properties, guanabenz and related alpha-2 agonists also have considerable potential for clinical use in equine medicine

CoDEL - A Relationally Complete Language for Database Evolution

Software developers adapt to the fast-moving nature of software systems with agile development techniques. However, database developers lack the tools and concepts to keep pace. Data, already existing in a running product, needs to be evolved accordingly, usually by manually written SQL scripts. A promising approach in database research is to use a declarative database evolution language, which couples both schema and data evolution into intuitive operations. Existing database evolution languages focus on usability but did not aim for completeness. However, this is an inevitable prerequisite for reasonable database evolution to avoid complex and error-prone workarounds. We argue that relational completeness is the feasible expressiveness for a database evolution language. Building upon an existing language, we introduce CoDEL. We define its semantic using relational algebra, propose a syntax, and show its relational completeness